home *** CD-ROM | disk | FTP | other *** search
/ Amiga Plus 2002 #3 / Amiga Plus CD - 2002 - No. 03.iso / AmigaPlus / AmigaOS / Aplus_Dev / AP-Website / links / admin / delete_site.php < prev    next >
Encoding:
PHP Script  |  2002-10-28  |  3.9 KB  |  172 lines

  1. <?
  2. // *******************************************************************
  3. //  admin/delete_category.php
  4. // *******************************************************************
  5.  
  6. include("../include/config.php");
  7. include("../include/functions.php");
  8.  
  9. include("../include/common.php");
  10. $language = $gl["Language"];
  11.  
  12. include("../include/lang/$language.php");
  13.  
  14. include("../include/session.php");
  15. session_start();
  16. ?>
  17. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
  18. "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 
  19. <html>
  20. <head>
  21. <title></title>
  22. <link rel = "stylesheet" type = "text/css" href = "style.css" />
  23. </head>
  24. <?=$adm_body?><?
  25.  
  26. if(isset($ID) && isset($sure)){
  27.     
  28.     if($dbtable == "links"){
  29.         
  30.         $sql = "
  31.             delete from
  32.                 $tb_links
  33.             where
  34.                 ID='$ID'
  35.         ";
  36.  
  37.     } else {
  38.  
  39.         $sql = "
  40.             delete from
  41.                 $tb_temp
  42.             where
  43.                 ID='$ID'
  44.         ";
  45.         
  46.         if($email_deletion == "Y"){
  47.             include("../include/email_deletion.php");
  48.         }
  49.     }
  50.     
  51.     $delete = sql_query($sql);
  52.  
  53. ?><table cellspacing="0" cellpadding="5" border="1" align="center" width="100%">
  54.     <tr>
  55.         <td align="center" class="theader">Site has been Deleted.<?
  56.         
  57.         if(!isset($dupes)){
  58.             
  59.             $temp_sites = sql_query("select * from $tb_temp");
  60.             
  61.             if(sql_num_rows($temp_sites)>0){
  62.                 ?><br><br><a href="sites_main.php?<?=session_name()?>=<?=session_id()?>&submit=1&Category=-1">
  63.                 Validate More Sites</a><?
  64.             }
  65.  
  66.         } else {
  67.             ?><br><br><a href="dupes.php?<?=session_name()?>=<?=session_id()?>">Remove More Duplicates</a><?
  68.         }
  69.         ?></td>
  70.     </tr>
  71.     </table>
  72.     <br><?
  73.     
  74.     if(isset($p) && $p=1){
  75.         ?><table cellspacing="0" cellpadding="5" border="1" align="center" width="100%">
  76.         <tr>
  77.             <td align="center"><a href="javascript:window.close();">Close Window</a></td>
  78.         </tr>
  79.         </table>
  80.         <br><?
  81.     }
  82. }
  83.  
  84. if(isset($notsure)){
  85.     ?><table cellspacing="0" cellpadding="5" border="1" align="center" width="100%">
  86.     <tr>
  87.         <td align="center" class="theader">Site has not been Deleted.<?
  88.             if(!isset($dupes)){
  89.                 
  90.                 $temp_sites = sql_query("
  91.                     select
  92.                         *
  93.                     from
  94.                         $tb_temp
  95.                 ");
  96.                 
  97.                 if(sql_num_rows($temp_sites)>0){
  98.                     ?><br><br><a href="sites_main.php?<?=session_name()?>=<?=session_id()?>&submit=1&Category=-1">
  99.                         Validate More Sites</a><?
  100.                 }
  101.             } else {
  102.                 ?><br><br><a href="dupes.php?<?=session_name()?>=<?=session_id()?>">Remove More Duplicates</a><?
  103.             }
  104.             ?></td>
  105.     </tr>
  106.     </table>
  107.     <br><?
  108. }
  109.  
  110. if(isset($ID) && !isset($notsure) && !isset($sure)){
  111.  
  112.     if($dbtable == "links"){
  113.         
  114.         $sql = "
  115.             select
  116.                 *
  117.             from
  118.                 $tb_links
  119.             where
  120.                 ID='$ID'
  121.         ";
  122.  
  123.     } else {
  124.  
  125.         $sql = "
  126.             select
  127.                 *
  128.             from
  129.                 $tb_temp
  130.             where
  131.                 ID='$ID'
  132.         ";
  133.     }
  134.  
  135. $get_cat = sql_query($sql);
  136. $rows = sql_fetch_array($get_cat);
  137.  
  138. ?><form method="post" action="delete_site.php?<?=session_name()?>=<?=session_id()?>">
  139.     <input type="hidden" name="ID" value="<?=$ID?>"><?
  140.     
  141.     if(isset($p))    {
  142.         ?>    <input type="hidden" name="p" value="<?=$p?>"><?
  143.     }
  144.  
  145.     if(isset($dupes)){
  146.         ?><input type="hidden" name="dupes" value="<?=$dupes?>"><?
  147.     }
  148.  
  149.     ?><input type="hidden" name="dbtable" value="<?=$dbtable?>">
  150.         <table cellspacing="0" cellpadding="5" border="1" align="center" width="100%">
  151.         <tr>
  152.             <td align="center" class="theader">Are you sure you want to delete site with ID 
  153.             <?=$rows[ID]?>?<br><br><input type="submit" name="sure" value="Yes">
  154.              <input type="submit" name="notsure" value="No"></td>
  155.         </tr>
  156.         </table>
  157.         </form><?
  158.     }
  159.  
  160.     if(!isset($ID)){
  161.     
  162.         ?><table cellspacing="0" cellpadding="5" border="1" align="center" width="100%">
  163.             <tr><form method="post" action="delete_site.php?<?=session_name()?>=<?=session_id()?>">
  164.                 <td align="center">Please enter a site ID to delete: 
  165.                 <input class="small" type="text" name="ID" size="5"> 
  166.                 <input class="button" type="submit" name="delete" value="Delete Site"></td>
  167.             </form></tr>
  168.             </table><?
  169.     }
  170. ?></body>
  171. </html>
  172.